/*
 Navicat Premium Data Transfer

 Source Server         : 127
 Source Server Type    : MySQL
 Source Server Version : 80000 (8.0.0-dmr)
 Source Host           : localhost:3306
 Source Schema         : node_db_1

 Target Server Type    : MySQL
 Target Server Version : 80000 (8.0.0-dmr)
 File Encoding         : 65001

 Date: 21/01/2024 22:31:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dp_group
-- ----------------------------
DROP TABLE IF EXISTS `dp_group`;
CREATE TABLE `dp_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `condition` json DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:千瓜平台,2:小红书话题',
  `status_msg` varchar(50) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0：未开始,1:抓取中,2:已完成',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `down_url` varchar(255) DEFAULT NULL,
  `create_id` int(11) DEFAULT NULL,
  `creator` varchar(50) DEFAULT NULL,
  `columns` json DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of dp_group
-- ----------------------------
BEGIN;
INSERT INTO `dp_group` (`id`, `title`, `condition`, `type`, `status_msg`, `status`, `created_at`, `updated_at`, `down_url`, `create_id`, `creator`, `columns`) VALUES (1, '测试任务信息', '{\"title\": \"万紫千红\", \"end_date\": \"2024-01-20\", \"pagesize\": 20, \"start_date\": \"2024-01-20\"}', 2, '开始抓取数据', 1, '2024-01-20 12:13:49', '2024-01-21 14:29:37', NULL, 1, '管理员', '[\"title\", \"nickname\", \"public_date\", \"read_num\", \"imp_num\", \"engage_num\", \"fav_num\", \"is_cooper_note\", \"content\"]');
INSERT INTO `dp_group` (`id`, `title`, `condition`, `type`, `status_msg`, `status`, `created_at`, `updated_at`, `down_url`, `create_id`, `creator`, `columns`) VALUES (2, '【Batc4】 KOL提报1.12_2024-01-20 20:19:31', NULL, 1, '数据抓取中……', 1, '2024-01-20 12:19:44', '2024-01-21 14:30:47', NULL, 1, '管理员', '[\"read_median_num\", \"interaction_median_num\", \"female_ratio\", \"active_fans_ratio\", \"gouache_ratio\", \"estimate_vv_num\", \"estimate_like_num\", \"four_line_ratio\"]');
INSERT INTO `dp_group` (`id`, `title`, `condition`, `type`, `status_msg`, `status`, `created_at`, `updated_at`, `down_url`, `create_id`, `creator`, `columns`) VALUES (3, '【Batc4】 KOL提报1.12_2024-01-20 20:43:36', NULL, 1, '数据抓取中……', 1, '2024-01-20 12:43:53', '2024-01-21 14:30:58', NULL, 1, '管理员', NULL);
INSERT INTO `dp_group` (`id`, `title`, `condition`, `type`, `status_msg`, `status`, `created_at`, `updated_at`, `down_url`, `create_id`, `creator`, `columns`) VALUES (4, '【Batc4】 KOL提报1.12_2024-01-20 20:45:12', NULL, 1, '数据抓取中……', 1, '2024-01-20 12:45:20', '2024-01-21 14:31:00', NULL, 1, '管理员', NULL);
COMMIT;

-- ----------------------------
-- Table structure for dp_pgy
-- ----------------------------
DROP TABLE IF EXISTS `dp_pgy`;
CREATE TABLE `dp_pgy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL COMMENT '达人名称',
  `red_id` varchar(50) DEFAULT NULL COMMENT '达人id',
  `link_url` varchar(255) DEFAULT NULL COMMENT '小红书主页链接',
  `blogger_id` int(11) DEFAULT NULL,
  `blogger_id_key` varchar(255) DEFAULT NULL,
  `is_fetch_data` varchar(255) DEFAULT NULL,
  `is_exception` tinyint(1) NOT NULL DEFAULT '0',
  `msg` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of dp_pgy
-- ----------------------------
BEGIN;
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (1, 4, 'Mandy是曼曼啊', 'Mandy_168', 'https://www.xiaohongshu.com/user/profile/5ad8a0df4eacab312f1c4d34', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (2, 4, '医学硕士小朱妈妈Nancy', '119511175', 'https://www.xiaohongshu.com/user/profile/5b0f72644eacab538ce4bf34?xhsshare=WeixinSession&appuid=618b379e00000000210240e8&apptime=1663129000', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (3, 4, '高姐讲育婴', '6010627018', 'https://www.xiaohongshu.com/user/profile/625638c700000000100083b8', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (4, 4, '育婴师月亮姐姐', '1496332843', 'https://www.xiaohongshu.com/user/profile/61b5a3920000000010006b68', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (5, 4, '育婴师培培', '2134672866', 'https://www.xiaohongshu.com/user/profile/61da305f00000000100056ef?xhsshare=WeixinSession&appuid=55cc68dbb7ba2233f7a701c4&apptime=1679997491', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (6, 4, '杰瑞米妈妈', '221242047', 'https://www.xiaohongshu.com/user/profile/5c54f012000000001b028afd', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (7, 4, '小米粒育儿日记', '226371514', 'https://www.xiaohongshu.com/user/profile/5c47306f000000001200928c', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (8, 4, '营养学悟空妈妈Jodie', 'wukongsmammy', 'https://www.xiaohongshu.com/user/profile/58e0291150c4b46a89050fab', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (9, 4, 'Stanley麻麻', '599441581', 'https://www.xiaohongshu.com/user/profile/5d6bcf8e0000000001002697', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (10, 4, '营养师赵兆', '942366690', 'https://www.xiaohongshu.com/user/profile/58ae3e8c6a6a6954f2c49c55', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (11, 4, '只讲干货的恩诺', 'EnnoLai', 'https://www.xiaohongshu.com/user/profile/579acaa850c4b447431c9b1e', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (12, 4, '石榴妈妈', '740360945', 'https://www.xiaohongshu.com/user/profile/5ca7dfc30000000017003d70', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (13, 4, '博士妈妈张慢鱼', 'vanliner0609', 'https://www.xiaohongshu.com/user/profile/5ac42c614eacab4d1bb027be', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (14, 4, '年年有鱼', '542819129', 'https://www.xiaohongshu.com/user/profile/5b83d411f25aeb0001babd4f', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (15, 4, '医学硕士菲菲', 'Eline2563', 'https://www.xiaohongshu.com/user/profile/5db430580000000001005ef8', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (16, 4, '儿科黄奶奶', '1091685732', 'https://www.xiaohongshu.com/user/profile/5fc9da61000000000100ac83', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (17, 4, '小白鹭白又白（三胎孕期）', 'mr6232', 'https://www.xiaohongshu.com/user/profile/58e1c6b250c4b41996f85642', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (18, 4, '育婴师安安妈', '738010931', 'https://www.xiaohongshu.com/user/profile/5f2ecf3b0000000001003c35', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (19, 4, '点妈（董礼貌）', '635700854', 'https://www.xiaohongshu.com/user/profile/5a85c14f4eacab616a62c1af', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (20, 4, '抱走老西儿', '271385195', 'https://www.xiaohongshu.com/user/profile/5b14a5af4eacab0cdcb67fdc', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (21, 4, '兴兴养丸', 'xingxingyangwan', 'https://www.xiaohongshu.com/user/profile/56783870e4251d6509ed1f7d', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (22, 4, '笑果爸爸爱生活', '422183338', 'https://www.xiaohongshu.com/user/profile/59ec1a8edb2e600b1ab74dbe', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (23, 4, '我是安崽妈', '251357602', 'https://www.xiaohongshu.com/user/profile/5ebed47e000000000101c3df', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (24, 4, '柒柒团子', '2201628950', 'https://www.xiaohongshu.com/user/profile/6486857b000000001003407f', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (25, 4, '橡阳而生', 'S_D13140520', 'https://www.xiaohongshu.com/user/profile/5ab5998fe8ac2b7a041f6726', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (26, 4, '是泡芙妈啊', '489134181', 'https://www.xiaohongshu.com/user/profile/5e103d850000000001006f2a', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (27, 4, '两只小朱的妈妈', '294604918', 'https://www.xiaohongshu.com/user/profile/55befe805894465574ea6bef', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (28, 4, '柴花花_育儿经', 'Chh6108', 'https://www.xiaohongshu.com/user/profile/54be0799b4c4d63cf6914971', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (29, 4, '橙子妈露露', '552505643', 'https://www.xiaohongshu.com/user/profile/5c5573870000000010008ec3', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (30, 4, '大大大怡_', '102155798', 'https://www.xiaohongshu.com/user/profile/55b8ea395894466783d167c1', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (31, 4, 'sunshine_是阿暖呀', 'dd1988115', 'https://www.xiaohongshu.com/user/profile/591828ce50c4b47f26329bfc', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (32, 4, '智爸育儿说', '183778028', 'https://www.xiaohongshu.com/user/profile/5b0487b1e8ac2b4f0b718e5c', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (33, 4, '陈意意', '490649103', 'https://www.xiaohongshu.com/user/profile/5b0979714eacab0ea8e726d1?wechatWid=b7449dd5130d63f0b26a52f07aafbe6d&wechatOrigin=menu', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (34, 4, '平平无奇的小周', '106056313', 'https://www.xiaohongshu.com/user/profile/5755226b6a6a6944353df642', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (35, 4, '哈佛亮爸教育规划', '6140287191', 'https://www.xiaohongshu.com/user/profile/642e876e000000001201368a', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (36, 4, '糕爸威廉', '9586654790', 'https://www.xiaohongshu.com/user/profile/6136c2510000000002027bce', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (37, 4, '包子妈', '497560444', 'https://www.xiaohongshu.com/user/profile/5a0ec64be8ac2b0bbf1984bb', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (38, 4, '二胎爸爸史蒂夫', '311546827', 'https://www.xiaohongshu.com/user/profile/5f199822000000000101c117', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (39, 4, '马蕾孕哺育', '565969575', 'https://www.xiaohongshu.com/user/profile/5ba4ab07e839fb00014b2129', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (40, 4, '沈奕斐和商建刚', '1140023091', 'https://www.xiaohongshu.com/user/profile/609a89410000000001009dc4', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (41, 4, '刘虔🔑国际婴儿睡眠咨询师', 'qianxiaoyang75', 'https://www.xiaohongshu.com/user/profile/5bfa0d262522590001b30111', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (42, 4, '小开心妈妈', '106124073', 'https://www.xiaohongshu.com/user/profile/56421e21e58d1307c57807fe', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (43, 4, '欢喜妈妈说', 'huanxi_mama_say', 'https://www.xiaohongshu.com/user/profile/5b8ff3e2f7e8b92d6f311073', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (44, 4, '妞妈Nora', 'youngspicy_', 'https://www.xiaohongshu.com/user/profile/5cf6432e0000000010022698', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (45, 4, '桃子momo', 'peachesmomo', 'https://www.xiaohongshu.com/user/profile/5d396cf3000000001003f138', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (46, 4, '智慧育儿推荐官', 'xysmy666', 'https://www.xiaohongshu.com/user/profile/633e4c67000000001901d5fe', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (47, 4, '啵啵妈也是林老师🌺', '151001236', 'https://www.xiaohongshu.com/user/profile/5bd32350313b650001257123', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (48, 4, '幸运Lucas的妈妈', 'yingxiaoyi', 'https://www.xiaohongshu.com/user/profile/5837a5207fc5b86b38290791', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (49, 4, '瑞秋姐姐', '128806298', 'https://www.xiaohongshu.com/user/profile/5df3059f000000000100a999', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (50, 4, '老丁头家的小胖苏', 'suminwxyd', 'https://www.xiaohongshu.com/user/profile/57995dda6a6a6952a89a28d8', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (51, 4, '育婴师木木', '1439256655', 'https://www.xiaohongshu.com/user/profile/6207521f000000001000e0d8', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (52, 4, '是宝贝贴贴吖', '600332167', 'https://www.xiaohongshu.com/user/profile/5655a97b03eb8456975ffc62', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (53, 4, '魔都妈妈备孕三胎', 'mumumama01', 'https://www.xiaohongshu.com/user/profile/5b80fe0f26cd5c0001ffb3c9', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (54, 4, '郑奶奶科学育儿', 'zhengnainai0914', 'https://www.xiaohongshu.com/user/profile/62230f4f0000000010006918', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
INSERT INTO `dp_pgy` (`id`, `group_id`, `name`, `red_id`, `link_url`, `blogger_id`, `blogger_id_key`, `is_fetch_data`, `is_exception`, `msg`, `created_at`, `updated_at`) VALUES (55, 4, '老谢带娃记', '2191936545', 'https://www.xiaohongshu.com/user/profile/6245a46500000000210202c4', NULL, NULL, NULL, 0, NULL, '2024-01-20 12:45:20', '2024-01-20 12:45:20');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `real_name` varchar(50) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` (`id`, `username`, `real_name`, `password`, `status`) VALUES (1, 'admin', '管理员', '7fef6171469e80d32c0559f88b377245', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
